#! /bin/bash
export LANG=zh_CN.UTF-8
HIVE_HOME=/usr/bin/hive


${HIVE_HOME} -S -e "
set hive.exec.dynamic.partition.mode=nonstrict;
insert overwrite table zxedu_dwd.fact_customer_relationship partition (start_date)
select id,
       create_date_time,
       update_date_time,
       deleted,
       customer_id,
       first_id,
       belonger,
       belonger_name,
       initial_belonger,
       distribution_handler,
       business_scrm_department_id,
       last_visit_time,
       next_visit_time,
       origin_type,
       itcast_school_id,
       itcast_subject_id,
       intention_study_type,
       anticipat_signup_date,
       level,
       creator,
       current_creator,
       creator_name,
       origin_channel,
       comment,
       first_customer_clue_id,
       last_customer_clue_id,
       process_state,
       process_time,
       payment_state,
       payment_time,
       signup_state,
       signup_time,
       notice_state,
       notice_time,
       lock_state,
       lock_time,
       itcast_clazz_id,
       itcast_clazz_time,
       payment_url,
       payment_url_time,
       ems_student_id,
       delete_reason,
       deleter,
       deleter_name,
       delete_time,
       course_id,
       course_name,
       delete_comment,
       close_state,
       close_time,
       appeal_id,
       tenant,
       total_fee,
       belonged,
       belonged_time,
       belonger_time,
       transfer,
       transfer_time,
       follow_type,
       transfer_bxg_oa_account,
       transfer_bxg_belonger_name,
       substring(create_date_time,1,4) as year_code,
       substring(create_date_time,1,7) as month_code,
       substring(create_date_time,1,10) as date_code,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.customer_relationship;

insert overwrite table zxedu_dwd.fact_customer_appeal partition (start_date)
select id,
       customer_relationship_first_id,
       employee_id,
       employee_name,
       employee_department_id,
       employee_tdepart_id,
       appeal_status,
       audit_id,
       audit_name,
       audit_department_id,
       audit_department_name,
       audit_date_time,
       create_date_time,
       update_date_time,
       deleted,
       tenant,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.customer_appeal;

insert overwrite table zxedu_dwd.dimension_employee partition (start_date)
select id,
       email,
       real_name,
       phone,
       department_id,
       department_name,
       remote_login,
       job_number,
       cross_school,
       last_login_date,
       creator,
       create_date_time,
       update_date_time,
       deleted,
       scrm_department_id,
       leave_office,
       leave_office_time,
       reinstated_time,
       superior_leaders_id,
       tdepart_id,
       tenant,
       ems_user_name,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.employee;

insert overwrite table zxedu_dwd.dimension_scrm_department partition(start_date)
select id,
       name,
       parent_id,
       create_date_time,
       update_date_time,
       deleted,
       id_path,
       tdepart_code,
       creator,
       depart_level,
       depart_sign,
       depart_line,
       depart_sort,
       disable_flag,
       tenant,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.scrm_department;

insert overwrite table zxedu_dwd.dimension_itcast_school partition(start_date)
select id,
       create_date_time,
       update_date_time,
       deleted,
       name,
       code,
       tenant,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.itcast_school;

insert overwrite  table zxedu_dwd.dimension_itcast_subject partition(start_date)
select id,
       create_date_time,
       update_date_time,
       deleted,
       name,
       code,
       tenant,
       '9999-99-99' as end_date,
       dt as start_date
from zxedu_ods.itcast_subject;
"